package io.aircraft.modules.wms.dao;

import io.aircraft.modules.wms.entity.StockDetailEntity;
import io.aircraft.modules.wms.entity.StockEntity;
import io.aircraft.common.dao.BaseDao;
import io.aircraft.modules.wms.entity.StockUsableEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 库存数据表交互接口
 *
 * @author Cycle gengruyi01@163.com
 * @since 1.0.0 2022-10-13
 */
@Mapper
public interface StockDao extends BaseDao<StockEntity> {
    void unfreezeStock();

    String getStockBySpu(@Param("spuNo") String spuNo, @Param("lotNo") String lotNo);

    String getUsableStockBySpu(@Param("spuNo") String spuNo, @Param("lotNo") String lotNo);

    StockDetailEntity getStockDetails();

    List<StockDetailEntity> getStockDetailsGroupBySpu();

    String getUsableStockByDvc(StockUsableEntity parameter);

    List<StockEntity> getUsableStockListByDvc(StockUsableEntity parameter);
}